[dbo].[BAEOrderAttributeGetAllForProduct]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEOrderAttributeGetAllForProduct

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@OrderProductID	int	4

SQL Script

create procedure [dbo].[BAEOrderAttributeGetAllForProduct] @OrderProductID as
int
AS
    SELECT *
    FROM OrderSuperProductAttribute AS ospa JOIN OrderSuperProductAttributeLookup AS ospal ON
    ospa.OrderSuperProductAttributeID = ospal.OrderSuperProductAttributeID
    WHERE ospal.OrderProductID = @OrderProductID
    ORDER BY ospal.SortOrder;

GO

Uses

[dbo].[OrderSuperProductAttribute]
[dbo].[OrderSuperProductAttributeLookup]
dbo